﻿USE [iKBSystem]
GO

DECLARE @EntityKey AS [uniqueidentifier];
SET @EntityKey = '04B32D12-BCBC-4467-9B66-1C65EA90E71E';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScope] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScope] ([Key],[Name],[Code],[Type],[Description])
	VALUES (@EntityKey,'腾讯QQ','qq',1,null);

SET @EntityKey = 'B9492D13-68BD-4009-9F8B-9BC0C5A9D540';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','261906783','丁梦莲',getdate(),getdate());  

SET @EntityKey = '28BEF6D6-D464-46DC-8C76-3361D9718E5A';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','66728121','阅世',getdate(),getdate()); 

SET @EntityKey = '6724B78B-1FDF-42E2-93BC-224CC9B56BFE';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','52024210','Toni',getdate(),getdate());

SET @EntityKey = '9A773348-4566-4BD8-8878-706A35289BF4';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','568827145','虞贞珍',getdate(),getdate());

SET @EntityKey = '90DBF0F0-531A-4B82-AC5C-1C59212C02A8';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','122276765','陈文君',getdate(),getdate());

SET @EntityKey = '0968AE79-8995-4B69-97FB-6676CAF3805B';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','544504180','姚韵扉',getdate(),getdate());

SET @EntityKey = '171392EC-D806-4789-AB6F-3AEFAA07F315';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','495069349','佑佑',getdate(),getdate());

SET @EntityKey = '2606BAB6-E4F8-4E90-954B-D41DF2057269';
IF NOT EXISTS (SELECT * FROM [dbo].[DomainScopeUser] WHERE [Key] = @EntityKey)
	INSERT INTO [dbo].[DomainScopeUser] ([Key],[DomainScopeKey],[ThirdPartyIdentity],[Description],[CreatedStamp],[LastUpdatedStamp])
	VALUES (@EntityKey,'04B32D12-BCBC-4467-9B66-1C65EA90E71E','1571703673','大壞蛋MT-J',getdate(),getdate());
